Executive Summary and Troubles that Occurred 3

Executive Summary




Troubles that Occurred during the project.

  1. There was a lot of data stored in different Excel Sheets, columns like the Geography Country and State merged, duplicates. The data needed a lot of cleaning. I used SSIS, SQL and elimination, modification in Excel.
  2. The data is reported at the end of each Year that is 31st December. Which limited the date granularity in which I visualize the data, However I utilized the year as a filter to see the insights in the various programs, regions, States and Income levels.
  3. Using Year over Year measures over the views was a challenge. I did a lot of research on the topic.


1.

Sample of an Executive Overview Dashboard: https://www.youtube.com/watch?v=gapji0KMqUA